Dataset statistics
| Number of variables | 3 |
|---|---|
| Number of observations | 125086 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.9 MiB |
| Average record size in memory | 24.0 B |
Variable types
| Categorical | 1 |
|---|---|
| Numeric | 2 |
Reproduction
| Analysis started | 2022-11-23 20:36:18.208470 |
|---|---|
| Analysis finished | 2022-11-23 20:39:10.835837 |
| Duration | 2 minutes and 52.63 seconds |
| Software version | pandas-profiling vdev |
| Download configuration | config.json |
| Distinct | 125086 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 977.4 KiB |
| tt0000001 | 1 |
|---|---|
| tt2177418 | 1 |
| tt2177318 | 1 |
| tt2177167 | 1 |
| tt2177145 | 1 |
| Other values (125081) |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 9.1504565 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1144594 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 125086 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | tt0000001 |
|---|---|
| 2nd row | tt0000007 |
| 3rd row | tt0000009 |
| 4th row | tt0000031 |
| 5th row | tt0000061 |
Common Values
| Value | Count | Frequency (%) |
| tt0000001 | 1 | < 0.1% |
| tt2177418 | 1 | < 0.1% |
| tt2177318 | 1 | < 0.1% |
| tt2177167 | 1 | < 0.1% |
| tt2177145 | 1 | < 0.1% |
| tt2177125 | 1 | < 0.1% |
| tt2177115 | 1 | < 0.1% |
| tt2177113 | 1 | < 0.1% |
| tt2177007 | 1 | < 0.1% |
| tt2176948 | 1 | < 0.1% |
| Other values (125076) | 125076 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| tt0000001 | 1 | < 0.1% |
| tt0000031 | 1 | < 0.1% |
| tt0000085 | 1 | < 0.1% |
| tt0000089 | 1 | < 0.1% |
| tt0000096 | 1 | < 0.1% |
| tt0000102 | 1 | < 0.1% |
| tt0000107 | 1 | < 0.1% |
| tt0000119 | 1 | < 0.1% |
| tt0000132 | 1 | < 0.1% |
| tt0000135 | 1 | < 0.1% |
| Other values (125076) | 125076 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 250172 | |
| 0 | 132465 | |
| 1 | 111401 | |
| 2 | 95034 | 8.3% |
| 4 | 88852 | 7.8% |
| 6 | 86315 | 7.5% |
| 8 | 82800 | 7.2% |
| 3 | 79201 | 6.9% |
| 5 | 76556 | 6.7% |
| 7 | 72701 | 6.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 894422 | |
| Lowercase Letter | 250172 | 21.9% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 132465 | |
| 1 | 111401 | |
| 2 | 95034 | |
| 4 | 88852 | |
| 6 | 86315 | |
| 8 | 82800 | |
| 3 | 79201 | |
| 5 | 76556 | |
| 7 | 72701 | |
| 9 | 69097 |
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 250172 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 894422 | |
| Latin | 250172 | 21.9% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 132465 | |
| 1 | 111401 | |
| 2 | 95034 | |
| 4 | 88852 | |
| 6 | 86315 | |
| 8 | 82800 | |
| 3 | 79201 | |
| 5 | 76556 | |
| 7 | 72701 | |
| 9 | 69097 |
Latin
| Value | Count | Frequency (%) |
| t | 250172 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1144594 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 250172 | |
| 0 | 132465 | |
| 1 | 111401 | |
| 2 | 95034 | 8.3% |
| 4 | 88852 | 7.8% |
| 6 | 86315 | 7.5% |
| 8 | 82800 | 7.2% |
| 3 | 79201 | 6.9% |
| 5 | 76556 | 6.7% |
| 7 | 72701 | 6.4% |
averageRating
Real number (ℝ)
| Distinct | 91 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.9495467 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 977.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4.4 |
| Q1 | 6.2 |
| median | 7.1 |
| Q3 | 7.9 |
| 95-th percentile | 8.9 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 1.7 |
Descriptive statistics
| Standard deviation | 1.3900248 |
|---|---|
| Coefficient of variation (CV) | 0.20001662 |
| Kurtosis | 1.114094 |
| Mean | 6.9495467 |
| Median Absolute Deviation (MAD) | 0.8 |
| Skewness | -0.79938617 |
| Sum | 869291 |
| Variance | 1.9321691 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7.2 | 4627 | 3.7% |
| 7.6 | 4470 | 3.6% |
| 7.8 | 4380 | 3.5% |
| 7.4 | 4379 | 3.5% |
| 7 | 4321 | 3.5% |
| 7.5 | 4107 | 3.3% |
| 8 | 4043 | 3.2% |
| 6.8 | 3956 | 3.2% |
| 7.3 | 3941 | 3.2% |
| 7.7 | 3801 | 3.0% |
| Other values (81) | 83061 |
| Value | Count | Frequency (%) |
| 1 | 109 | |
| 1.1 | 18 | < 0.1% |
| 1.2 | 45 | |
| 1.3 | 32 | < 0.1% |
| 1.4 | 31 | < 0.1% |
| 1.5 | 44 | |
| 1.6 | 49 | |
| 1.7 | 45 | |
| 1.8 | 45 | |
| 1.9 | 48 |
| Value | Count | Frequency (%) |
| 10 | 566 | |
| 9.9 | 142 | 0.1% |
| 9.8 | 293 | 0.2% |
| 9.7 | 232 | 0.2% |
| 9.6 | 408 | |
| 9.5 | 315 | 0.3% |
| 9.4 | 537 | |
| 9.3 | 517 | |
| 9.2 | 927 | |
| 9.1 | 715 |
numVotes
Real number (ℝ)
| Distinct | 5737 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1071.9301 |
| Minimum | 5 |
|---|---|
| Maximum | 2038650 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 977.4 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 12 |
| median | 26 |
| Q3 | 103 |
| 95-th percentile | 1375.75 |
| Maximum | 2038650 |
| Range | 2038645 |
| Interquartile range (IQR) | 91 |
Descriptive statistics
| Standard deviation | 16649.255 |
|---|---|
| Coefficient of variation (CV) | 15.532034 |
| Kurtosis | 3508.4993 |
| Mean | 1071.9301 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | 47.577186 |
| Sum | 1.3408345 × 108 |
| Variance | 2.7719768 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7 | 5165 | 4.1% |
| 8 | 5056 | 4.0% |
| 6 | 4818 | 3.9% |
| 9 | 4786 | 3.8% |
| 10 | 4289 | 3.4% |
| 11 | 3954 | 3.2% |
| 12 | 3622 | 2.9% |
| 13 | 3253 | 2.6% |
| 14 | 3094 | 2.5% |
| 5 | 3017 | 2.4% |
| Other values (5727) | 84032 |
| Value | Count | Frequency (%) |
| 5 | 3017 | |
| 6 | 4818 | |
| 7 | 5165 | |
| 8 | 5056 | |
| 9 | 4786 | |
| 10 | 4289 | |
| 11 | 3954 | |
| 12 | 3622 | |
| 13 | 3253 | |
| 14 | 3094 |
| Value | Count | Frequency (%) |
| 2038650 | 1 | |
| 1397275 | 1 | |
| 1233535 | 1 | |
| 1173251 | 1 | |
| 1111258 | 1 | |
| 1035355 | 1 | |
| 852313 | 1 | |
| 815591 | 1 | |
| 815589 | 1 | |
| 776363 | 1 |
Auto
The auto setting is an interpretable pairwise column metric of the following mapping:- Variable_type-Variable_type : Method, Range
- Categorical-Categorical : Cramer's V, [0,1]
- Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
- Numerical-Numerical : Spearman's ρ, [-1,1]
This configuration uses the recommended metric for each pair of columns.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| tconst | averageRating | numVotes | |
|---|---|---|---|
| 0 | tt0000001 | 5.7 | 1924 |
| 1 | tt0000007 | 5.4 | 798 |
| 2 | tt0000009 | 5.3 | 200 |
| 3 | tt0000031 | 5.5 | 982 |
| 4 | tt0000061 | 3.9 | 24 |
| 5 | tt0000085 | 4.7 | 33 |
| 6 | tt0000089 | 6.2 | 982 |
| 7 | tt0000096 | 4.3 | 29 |
| 8 | tt0000102 | 4.6 | 26 |
| 9 | tt0000107 | 5.2 | 28 |
| tconst | averageRating | numVotes | |
|---|---|---|---|
| 125076 | tt9915156 | 6.4 | 48 |
| 125077 | tt9915646 | 8.8 | 22 |
| 125078 | tt9915754 | 8.9 | 7 |
| 125079 | tt9915780 | 6.5 | 48 |
| 125080 | tt9915824 | 7.9 | 44 |
| 125081 | tt9915864 | 7.6 | 105 |
| 125082 | tt9915912 | 7.7 | 318 |
| 125083 | tt9916160 | 6.4 | 49 |
| 125084 | tt9916270 | 5.8 | 1376 |
| 125085 | tt9916778 | 7.3 | 35 |